How to: Create an embedded chart using CHART Wizard.
Solution:
Select the rows/columns to chart and select the 'Insert' menu and select 'Chart' the select 'On this Sheet'.
1) Open the desired workbook.
2) Click the tab for the worksheet that contains the desired data and where the new chart should appear.
3) Select the rows and/or columns to chart, including any label text.
4) Select 'Chart' from the 'Insert' menu. (A submenu appears.)
5) Select 'On This Sheet' from the submenu. (The pointer changes to a plus sign with a tiny column chart.)
NOTE: Clicking 'ChartWizard' on the 'Standard toolbar' also creates the same result.
ChartWizard button
6) Draw the area where the chart should appear on the worksheet.
a) Place the pointer on one corner of the desired area.
b) Press and hold down the mouse button.
c) Drag the pointer to draw the size of the chart area.
d) Release the mouse button when the desired size is reached. (The ChartWizard Step 1 of 5 dialog box appears.)
ChartWizard Step 1 of 5
7) Make sure the range in the 'Range' box of the displayed dialog box is correct.
NOTE: The range in the 'Range' box defaults to the data selected in Step 3).
8) Click 'Next'. (The ChartWizard - Step 2 of 5 dialog box appears.)
ChartWizard Step 2 of 5
9) Select the desired chart type from the 'Select a chart type' box.
10) Click 'Next'. (The ChartWizard - Step 3 of 5 dialog box appears.)
ChartWizard Step 3 of 5
11) Select the desired format for the chart from the 'Select a format for the <x> chart' box, where <x> stands for the type of chart selected in Step 9).
12) Click 'Next'. (The ChartWizard - Step 4 of 5 dialog box appears with a sample chart that uses the selected data.)
ChartWizard Step 4 of 5
13) Make sure that the sample chart correctly presents the selected data.
14) (Optional) To change the data presentation, do one or more of the following:
a) Change to the other option in the 'Data Series in' group.
b) Specify the row containing the text to use as the X-axis labels in the 'Category (X)' box.
c) Specify the column containing the text to use as the Y-axis labels in the 'Value (Y)' box.
15) Click 'Next'. (The ChartWizard - Step 5 of 5 dialog box appears.)
ChartWizard step 5 of 5
NOTE: The sample chart in this dialog box incorporates any changes made in the previous dialog box.
16) (Optional) Specify whether to add a legend to the chart in the 'Add a Legend?' group.
NOTE: Any additions or changes made in the dialog box are immediately reflected in the sample chart.
17) (Optional) Type a title for the chart in the 'Chart Title' box.
18) (Optional) Type a title for the X-axis in the 'Category (X)' box of the 'Axis Titles' group.
19) (Optional) Type a title for the Y-axis in the 'Value (Y)' box of the 'Axis Titles' group.
20) Click 'Finish'. (A chart appears in the worksheet.)
21) (Optional) Resize the chart so that it appears properly.
